Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 19401 |
| Missing cells (%) | 6.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 11.5 MiB |
| Average record size in memory | 1.2 KiB |
Variable types
| NUM | 13 |
|---|---|
| CAT | 13 |
| BOOL | 3 |
Reproduction
| Analysis started | 2020-11-04 13:32:06.527267 |
|---|---|
| Analysis finished | 2020-11-04 13:33:10.450852 |
| Version | pandas-profiling v2.6.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
emp_title has a high cardinality: 7902 distinct values | High cardinality |
Notes has a high cardinality: 6759 distinct values | High cardinality |
purpose has a high cardinality: 5160 distinct values | High cardinality |
zip_code has a high cardinality: 720 distinct values | High cardinality |
emp_title has 592 (5.9%) missing values | Missing |
Notes has 3230 (32.3%) missing values | Missing |
mths_since_last_delinq has 6316 (63.2%) missing values | Missing |
mths_since_last_record has 9160 (91.6%) missing values | Missing |
emp_length has 250 (2.5%) zeros | Zeros |
delinq_2yrs has 8910 (89.1%) zeros | Zeros |
inq_last_6mths has 4602 (46.0%) zeros | Zeros |
mths_since_last_delinq has 163 (1.6%) zeros | Zeros |
mths_since_last_record has 267 (2.7%) zeros | Zeros |
revol_bal has 278 (2.8%) zeros | Zeros |
revol_util has 254 (2.5%) zeros | Zeros |
is_bad
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 0 | |
|---|---|
| 1 | 1295 |
| Value | Count | Frequency (%) | |
| 0 | 8705 | 87.1% | |
| 1 | 1295 | 13.0% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
| Distinct count | 7902 |
|---|---|
| Unique (%) | 84.0% |
| Missing | 592 |
| Missing (%) | 5.9% |
| Memory size | 78.2 KiB |
| us army | 54 |
|---|---|
| bank of america | 34 |
| ibm | 23 |
| wells fargo | 21 |
| self | 20 |
| Other values (7897) |
| Value | Count | Frequency (%) | |
| us army | 54 | 0.5% | |
| bank of america | 34 | 0.3% | |
| ibm | 23 | 0.2% | |
| wells fargo | 21 | 0.2% | |
| self | 20 | 0.2% | |
| us navy | 20 | 0.2% | |
| walmart | 20 | 0.2% | |
| at&t | 18 | 0.2% | |
| united states air force | 17 | 0.2% | |
| usaf | 17 | 0.2% | |
| Other values (7892) | 9164 | 91.6% | |
| (Missing) | 592 | 5.9% |
Length
| Max length | 78 |
|---|---|
| Mean length | 17.4252 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 29 | 46.0% | |
| Other_Punctuation | 11 | 17.5% | |
| Decimal_Number | 10 | 15.9% | |
| Open_Punctuation | 2 | 3.2% | |
| Currency_Symbol | 1 | 1.6% | |
| Control | 1 | 1.6% | |
| Other_Symbol | 1 | 1.6% | |
| Modifier_Symbol | 1 | 1.6% | |
| Final_Punctuation | 1 | 1.6% | |
| Close_Punctuation | 1 | 1.6% | |
| Other values (5) | 5 | 7.9% |
| Value | Count | Frequency (%) | |
| Common | 34 | 54.0% | |
| Latin | 29 | 46.0% |
| Value | Count | Frequency (%) | |
| ASCII | 55 | 96.5% | |
| Punctuation | 2 | 3.5% |
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8639 |
|---|---|
| Minimum | 0 |
| Maximum | 33 |
| Zeros | 250 |
| Zeros (%) | 2.5% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.492219402 |
|---|---|
| Coefficient of variation (CV) | 0.7179875001 |
| Kurtosis | -0.7128269405 |
| Mean | 4.8639 |
| Median Absolute Deviation (MAD) | 3.0606037 |
| Skewness | 0.4600047179 |
| Sum | 48639 |
| Variance | 12.19559635 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 6.5 7.5 9.5 10.5 33. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 10 | 2160 | 21.6% | |
| 1 | 2083 | 20.8% | |
| 2 | 1183 | 11.8% | |
| 3 | 1010 | 10.1% | |
| 4 | 889 | 8.9% | |
| 5 | 779 | 7.8% | |
| 6 | 535 | 5.3% | |
| 7 | 421 | 4.2% | |
| 8 | 351 | 3.5% | |
| 9 | 331 | 3.3% | |
| Other values (4) | 258 | 2.6% |
| Value | Count | Frequency (%) | |
| 0 | 250 | 2.5% | |
| 1 | 2083 | 20.8% | |
| 2 | 1183 | 11.8% | |
| 3 | 1010 | 10.1% | |
| 4 | 889 | 8.9% |
| Value | Count | Frequency (%) | |
| 33 | 1 | < 0.1% | |
| 22 | 5 | 0.1% | |
| 11 | 2 | < 0.1% | |
| 10 | 2160 | 21.6% | |
| 9 | 331 | 3.3% |
home_ownership
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| rent | |
|---|---|
| mortgage | |
| own | 775 |
| other | 34 |
| none | 1 |
| Value | Count | Frequency (%) | |
| rent | 4745 | 47.4% | |
| mortgage | 4445 | 44.5% | |
| own | 775 | 7.8% | |
| other | 34 | 0.3% | |
| none | 1 | < 0.1% |
Length
| Max length | 8 |
|---|---|
| Mean length | 5.7039 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 10 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 10 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 10 | 100.0% |
annual_inc
Real number (ℝ≥0)
| Distinct count | 1901 |
|---|---|
| Unique (%) | 19.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68203.01154 |
|---|---|
| Minimum | 2000 |
| Maximum | 900000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 23734 |
| Q1 | 40000 |
| median | 58000 |
| Q3 | 82000 |
| 95-th percentile | 143550 |
| Maximum | 900000 |
| Range | 898000 |
| Interquartile range (IQR) | 42000 |
Descriptive statistics
| Standard deviation | 48590.25276 |
|---|---|
| Coefficient of variation (CV) | 0.7124355899 |
| Kurtosis | 51.15309953 |
| Mean | 68203.01154 |
| Median Absolute Deviation (MAD) | 30247.19103 |
| Skewness | 4.880305421 |
| Sum | 681961912.4 |
| Variance | 2361012663 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 60000 | 381 | 3.8% | |
| 50000 | 267 | 2.7% | |
| 40000 | 222 | 2.2% | |
| 75000 | 213 | 2.1% | |
| 30000 | 211 | 2.1% | |
| 65000 | 204 | 2.0% | |
| 48000 | 196 | 2.0% | |
| 70000 | 193 | 1.9% | |
| 45000 | 181 | 1.8% | |
| 80000 | 170 | 1.7% | |
| Other values (1891) | 7761 | 77.6% |
| Value | Count | Frequency (%) | |
| 2000 | 1 | < 0.1% | |
| 4080 | 1 | < 0.1% | |
| 4200 | 2 | < 0.1% | |
| 4800 | 2 | < 0.1% | |
| 5000 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 900000 | 2 | < 0.1% | |
| 860000 | 1 | < 0.1% | |
| 780000 | 1 | < 0.1% | |
| 744000 | 1 | < 0.1% | |
| 725000 | 1 | < 0.1% |
verification_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| not verified | |
|---|---|
| verified - income | |
| verified - income source |
| Value | Count | Frequency (%) | |
| not verified | 4367 | 43.7% | |
| verified - income | 3214 | 32.1% | |
| verified - income source | 2419 | 24.2% |
Length
| Max length | 24 |
|---|---|
| Mean length | 16.5098 |
| Min length | 12 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 86.7% | |
| Dash_Punctuation | 1 | 6.7% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 13 | 86.7% | |
| Common | 2 | 13.3% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
pymnt_plan
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| n | |
|---|---|
| y | 2 |
| Value | Count | Frequency (%) | |
| n | 9998 | > 99.9% | |
| y | 2 | < 0.1% |
| Distinct count | 6759 |
|---|---|
| Unique (%) | 99.8% |
| Missing | 3230 |
| Missing (%) | 32.3% |
| Memory size | 78.2 KiB |
| personal loan | 4 |
|---|---|
| debt consolidation | 3 |
| this loan would be to consolidate my credit card debts, and have one payment at a reasonable interest rate. | 2 |
| credit card debt consolidation | 2 |
| refinancing | 2 |
| Other values (6754) |
| Value | Count | Frequency (%) | |
| personal loan | 4 | < 0.1% | |
| debt consolidation | 3 | < 0.1% | |
| this loan would be to consolidate my credit card debts, and have one payment at a reasonable interest rate. | 2 | < 0.1% | |
| credit card debt consolidation | 2 | < 0.1% | |
| refinancing | 2 | < 0.1% | |
| i am consolidating credit card debt. | 2 | < 0.1% | |
| i am a recent college graduate that is in need to pay down high interest credit card debt. i had to pay my own way through college and have student loans and credit card debt to show for it. i now have a good paying full time job and would like to pay down the high interest credit card debt that i have for a better financial future. | 2 | < 0.1% | |
| camping membership | 2 | < 0.1% | |
| borrower added on 06/30/10 > when will i get my loan in the bank<br/> borrower added on 06/30/10 > thank you<br/> borrower added on 06/30/10 > i what to open up my own business<br/> | 1 | < 0.1% | |
| borrower added on 05/18/10 > pay off credit cards and make some small home improvements.<br/> | 1 | < 0.1% | |
| Other values (6749) | 6749 | 67.5% | |
| (Missing) | 3230 | 32.3% |
Length
| Max length | 3988 |
|---|---|
| Mean length | 291.4693 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 34 | 39.1% | |
| Other_Punctuation | 15 | 17.2% | |
| Decimal_Number | 10 | 11.5% | |
| Math_Symbol | 6 | 6.9% | |
| Control | 4 | 4.6% | |
| Currency_Symbol | 3 | 3.4% | |
| Dash_Punctuation | 3 | 3.4% | |
| Modifier_Symbol | 2 | 2.3% | |
| Open_Punctuation | 2 | 2.3% | |
| Initial_Punctuation | 2 | 2.3% | |
| Other values (5) | 6 | 6.9% |
| Value | Count | Frequency (%) | |
| Common | 53 | 60.9% | |
| Latin | 34 | 39.1% |
| Value | Count | Frequency (%) | |
| ASCII | 68 | 94.4% | |
| Punctuation | 4 | 5.6% |
purpose_cat
Categorical
| Distinct count | 27 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| debt consolidation | |
|---|---|
| credit card | |
| other | |
| home improvement | 800 |
| major purchase | 546 |
| Other values (22) |
| Value | Count | Frequency (%) | |
| debt consolidation | 4454 | 44.5% | |
| credit card | 1273 | 12.7% | |
| other | 1026 | 10.3% | |
| home improvement | 800 | 8.0% | |
| major purchase | 546 | 5.5% | |
| small business | 461 | 4.6% | |
| car | 349 | 3.5% | |
| wedding | 250 | 2.5% | |
| medical | 183 | 1.8% | |
| moving | 159 | 1.6% | |
| Other values (17) | 499 | 5.0% |
Length
| Max length | 33 |
|---|---|
| Mean length | 13.9381 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 21 | 95.5% | |
| Space_Separator | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| Latin | 21 | 95.5% | |
| Common | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| ASCII | 22 | 100.0% |
| Distinct count | 5160 |
|---|---|
| Unique (%) | 51.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 78.2 KiB |
| debt consolidation | 760 |
|---|---|
| debt consolidation loan | 464 |
| personal loan | 231 |
| consolidation | 181 |
| personal | 169 |
| Other values (5155) |
| Value | Count | Frequency (%) | |
| debt consolidation | 760 | 7.6% | |
| debt consolidation loan | 464 | 4.6% | |
| personal loan | 231 | 2.3% | |
| consolidation | 181 | 1.8% | |
| personal | 169 | 1.7% | |
| home improvement | 158 | 1.6% | |
| credit card consolidation | 125 | 1.2% | |
| small business loan | 100 | 1.0% | |
| loan | 85 | 0.9% | |
| consolidation loan | 83 | 0.8% | |
| Other values (5150) | 7640 | 76.4% |
Length
| Max length | 80 |
|---|---|
| Mean length | 17.1821 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 30 | 43.5% | |
| Other_Punctuation | 17 | 24.6% | |
| Decimal_Number | 10 | 14.5% | |
| Math_Symbol | 3 | 4.3% | |
| Currency_Symbol | 2 | 2.9% | |
| Open_Punctuation | 2 | 2.9% | |
| Connector_Punctuation | 1 | 1.4% | |
| Space_Separator | 1 | 1.4% | |
| Modifier_Symbol | 1 | 1.4% | |
| Dash_Punctuation | 1 | 1.4% |
| Value | Count | Frequency (%) | |
| Common | 39 | 56.5% | |
| Latin | 30 | 43.5% |
| Value | Count | Frequency (%) | |
| ASCII | 61 | 95.3% | |
| Punctuation | 3 | 4.7% |
| Distinct count | 720 |
|---|---|
| Unique (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 100xx | 158 |
|---|---|
| 112xx | 141 |
| 945xx | 129 |
| 070xx | 125 |
| 606xx | 114 |
| Other values (715) |
| Value | Count | Frequency (%) | |
| 100xx | 158 | 1.6% | |
| 112xx | 141 | 1.4% | |
| 945xx | 129 | 1.3% | |
| 070xx | 125 | 1.2% | |
| 606xx | 114 | 1.1% | |
| 900xx | 107 | 1.1% | |
| 021xx | 99 | 1.0% | |
| 941xx | 95 | 0.9% | |
| 926xx | 94 | 0.9% | |
| 750xx | 93 | 0.9% | |
| Other values (710) | 8845 | 88.4% |
Length
| Max length | 5 |
|---|---|
| Mean length | 5 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Lowercase_Letter | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 10 | 90.9% | |
| Latin | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
addr_state
Categorical
| Distinct count | 50 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| ca | |
|---|---|
| ny | 958 |
| fl | 714 |
| tx | 700 |
| nj | 482 |
| Other values (45) |
| Value | Count | Frequency (%) | |
| ca | 1748 | 17.5% | |
| ny | 958 | 9.6% | |
| fl | 714 | 7.1% | |
| tx | 700 | 7.0% | |
| nj | 482 | 4.8% | |
| va | 392 | 3.9% | |
| il | 386 | 3.9% | |
| pa | 378 | 3.8% | |
| ga | 357 | 3.6% | |
| ma | 331 | 3.3% | |
| Other values (40) | 3554 | 35.5% |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 24 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 24 | 100.0% |
debt_to_income
Real number (ℝ≥0)
| Distinct count | 2585 |
|---|---|
| Unique (%) | 25.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.338704 |
|---|---|
| Minimum | 0 |
| Maximum | 29.99 |
| Zeros | 58 |
| Zeros (%) | 0.6% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.129 |
| Q1 | 8.16 |
| median | 13.41 |
| Q3 | 18.6925 |
| 95-th percentile | 23.93 |
| Maximum | 29.99 |
| Range | 29.99 |
| Interquartile range (IQR) | 10.5325 |
Descriptive statistics
| Standard deviation | 6.754211507 |
|---|---|
| Coefficient of variation (CV) | 0.5063619004 |
| Kurtosis | -0.8546793248 |
| Mean | 13.338704 |
| Median Absolute Deviation (MAD) | 5.669516109 |
| Skewness | -0.008777611376 |
| Sum | 133387.04 |
| Variance | 45.61937308 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.055 0.195 3.395 7.675 20.325 22.835 24.965 26.885 29.99 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 58 | 0.6% | |
| 12.48 | 16 | 0.2% | |
| 13.51 | 13 | 0.1% | |
| 10 | 13 | 0.1% | |
| 19.2 | 13 | 0.1% | |
| 18.14 | 13 | 0.1% | |
| 4.8 | 12 | 0.1% | |
| 17.82 | 12 | 0.1% | |
| 15.38 | 12 | 0.1% | |
| 22.43 | 12 | 0.1% | |
| Other values (2575) | 9826 | 98.3% |
| Value | Count | Frequency (%) | |
| 0 | 58 | 0.6% | |
| 0.11 | 1 | < 0.1% | |
| 0.12 | 1 | < 0.1% | |
| 0.13 | 1 | < 0.1% | |
| 0.14 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29.99 | 1 | < 0.1% | |
| 29.93 | 1 | < 0.1% | |
| 29.92 | 1 | < 0.1% | |
| 29.83 | 1 | < 0.1% | |
| 29.74 | 1 | < 0.1% |
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.148174087 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros | 8910 |
| Zeros (%) | 89.1% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5062698917 |
|---|---|
| Coefficient of variation (CV) | 3.416723543 |
| Kurtosis | 54.81013986 |
| Mean | 0.148174087 |
| Median Absolute Deviation (MAD) | 0.2641783123 |
| Skewness | 5.639317112 |
| Sum | 1481 |
| Variance | 0.2563092032 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 8910 | 89.1% | |
| 1 | 822 | 8.2% | |
| 2 | 186 | 1.9% | |
| 3 | 50 | 0.5% | |
| 4 | 14 | 0.1% | |
| 5 | 6 | 0.1% | |
| 6 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| (Missing) | 5 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 8910 | 89.1% | |
| 1 | 822 | 8.2% | |
| 2 | 186 | 1.9% | |
| 3 | 50 | 0.5% | |
| 4 | 14 | 0.1% |
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 6 | 0.1% |
| Distinct count | 20 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.066933467 |
|---|---|
| Minimum | 0 |
| Maximum | 25 |
| Zeros | 4602 |
| Zeros (%) | 46.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.47605196 |
|---|---|
| Coefficient of variation (CV) | 1.383452676 |
| Kurtosis | 23.67847049 |
| Mean | 1.066933467 |
| Median Absolute Deviation (MAD) | 1.01844467 |
| Skewness | 3.116059024 |
| Sum | 10664 |
| Variance | 2.178729389 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 4602 | 46.0% | |
| 1 | 2684 | 26.8% | |
| 2 | 1431 | 14.3% | |
| 3 | 731 | 7.3% | |
| 4 | 227 | 2.3% | |
| 5 | 152 | 1.5% | |
| 6 | 76 | 0.8% | |
| 7 | 42 | 0.4% | |
| 8 | 27 | 0.3% | |
| 9 | 10 | 0.1% | |
| Other values (10) | 13 | 0.1% | |
| (Missing) | 5 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 4602 | 46.0% | |
| 1 | 2684 | 26.8% | |
| 2 | 1431 | 14.3% | |
| 3 | 731 | 7.3% | |
| 4 | 227 | 2.3% |
| Value | Count | Frequency (%) | |
| 25 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 18 | 2 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% |
| Distinct count | 91 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 6316 |
| Missing (%) | 63.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.89033659 |
|---|---|
| Minimum | 0 |
| Maximum | 120 |
| Zeros | 163 |
| Zeros (%) | 1.6% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 18 |
| median | 34 |
| Q3 | 53 |
| 95-th percentile | 75 |
| Maximum | 120 |
| Range | 120 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 22.3614429 |
|---|---|
| Coefficient of variation (CV) | 0.6230491276 |
| Kurtosis | -0.8171447741 |
| Mean | 35.89033659 |
| Median Absolute Deviation (MAD) | 18.73116249 |
| Skewness | 0.2929154934 |
| Sum | 132220 |
| Variance | 500.0341287 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 163 | 1.6% | |
| 30 | 69 | 0.7% | |
| 34 | 66 | 0.7% | |
| 38 | 65 | 0.7% | |
| 23 | 65 | 0.7% | |
| 44 | 64 | 0.6% | |
| 24 | 64 | 0.6% | |
| 33 | 63 | 0.6% | |
| 20 | 63 | 0.6% | |
| 18 | 61 | 0.6% | |
| Other values (81) | 2941 | 29.4% | |
| (Missing) | 6316 | 63.2% |
| Value | Count | Frequency (%) | |
| 0 | 163 | 1.6% | |
| 1 | 6 | 0.1% | |
| 2 | 29 | 0.3% | |
| 3 | 40 | 0.4% | |
| 4 | 37 | 0.4% |
| Value | Count | Frequency (%) | |
| 120 | 1 | < 0.1% | |
| 115 | 1 | < 0.1% | |
| 97 | 1 | < 0.1% | |
| 96 | 1 | < 0.1% | |
| 95 | 1 | < 0.1% |
| Distinct count | 94 |
|---|---|
| Unique (%) | 11.2% |
| Missing | 9160 |
| Missing (%) | 91.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.65238095 |
|---|---|
| Minimum | 0 |
| Maximum | 119 |
| Zeros | 267 |
| Zeros (%) | 2.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 86 |
| Q3 | 101 |
| 95-th percentile | 115.05 |
| Maximum | 119 |
| Range | 119 |
| Interquartile range (IQR) | 101 |
Descriptive statistics
| Standard deviation | 46.18961922 |
|---|---|
| Coefficient of variation (CV) | 0.7491944108 |
| Kurtosis | -1.586694469 |
| Mean | 61.65238095 |
| Median Absolute Deviation (MAD) | 42.56052154 |
| Skewness | -0.3831245675 |
| Sum | 51788 |
| Variance | 2133.480924 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 267 | 2.7% | |
| 89 | 21 | 0.2% | |
| 116 | 18 | 0.2% | |
| 86 | 17 | 0.2% | |
| 87 | 17 | 0.2% | |
| 92 | 17 | 0.2% | |
| 100 | 16 | 0.2% | |
| 114 | 16 | 0.2% | |
| 104 | 16 | 0.2% | |
| 105 | 15 | 0.1% | |
| Other values (84) | 420 | 4.2% | |
| (Missing) | 9160 | 91.6% |
| Value | Count | Frequency (%) | |
| 0 | 267 | 2.7% | |
| 6 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 20 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 119 | 3 | < 0.1% | |
| 118 | 11 | 0.1% | |
| 117 | 10 | 0.1% | |
| 116 | 18 | 0.2% | |
| 115 | 10 | 0.1% |
open_acc
Real number (ℝ≥0)
| Distinct count | 36 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.334567284 |
|---|---|
| Minimum | 1 |
| Maximum | 39 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 9 |
| Q3 | 12 |
| 95-th percentile | 18 |
| Maximum | 39 |
| Range | 38 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.526589744 |
|---|---|
| Coefficient of variation (CV) | 0.4849276465 |
| Kurtosis | 1.838467994 |
| Mean | 9.334567284 |
| Median Absolute Deviation (MAD) | 3.516796938 |
| Skewness | 1.063599744 |
| Sum | 93299 |
| Variance | 20.49001471 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 7 | 1035 | 10.3% | |
| 6 | 990 | 9.9% | |
| 8 | 937 | 9.4% | |
| 9 | 929 | 9.3% | |
| 10 | 805 | 8.1% | |
| 5 | 763 | 7.6% | |
| 11 | 692 | 6.9% | |
| 4 | 631 | 6.3% | |
| 12 | 577 | 5.8% | |
| 13 | 487 | 4.9% | |
| Other values (26) | 2149 | 21.5% |
| Value | Count | Frequency (%) | |
| 1 | 7 | 0.1% | |
| 2 | 163 | 1.6% | |
| 3 | 374 | 3.7% | |
| 4 | 631 | 6.3% | |
| 5 | 763 | 7.6% |
| Value | Count | Frequency (%) | |
| 39 | 1 | < 0.1% | |
| 36 | 2 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 33 | 3 | < 0.1% | |
| 32 | 1 | < 0.1% |
pub_rec
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 78.2 KiB |
| 0 | |
|---|---|
| 1 | 550 |
| 2 | 18 |
| 3 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 9422 | 94.2% | |
| 1 | 550 | 5.5% | |
| 2 | 18 | 0.2% | |
| 3 | 5 | 0.1% | |
| (Missing) | 5 | 0.1% |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 57.1% | |
| Lowercase_Letter | 2 | 28.6% | |
| Other_Punctuation | 1 | 14.3% |
| Value | Count | Frequency (%) | |
| Common | 5 | 71.4% | |
| Latin | 2 | 28.6% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
| Distinct count | 8130 |
|---|---|
| Unique (%) | 81.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14271.0074 |
|---|---|
| Minimum | 0 |
| Maximum | 1207359 |
| Zeros | 278 |
| Zeros (%) | 2.8% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 277.95 |
| Q1 | 3524.5 |
| median | 8645.5 |
| Q3 | 16952.25 |
| 95-th percentile | 44554.85 |
| Maximum | 1207359 |
| Range | 1207359 |
| Interquartile range (IQR) | 13427.75 |
Descriptive statistics
| Standard deviation | 25437.9082 |
|---|---|
| Coefficient of variation (CV) | 1.782488614 |
| Kurtosis | 570.4140985 |
| Mean | 14271.0074 |
| Median Absolute Deviation (MAD) | 11728.71446 |
| Skewness | 16.32424653 |
| Sum | 142710074 |
| Variance | 647087173.7 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 2.550000e+01 7.825000e+02 5.878000e+03 ... 8.222900e+04 1.205955e+05 1.727790e+05 2.836010e+05 1.207359e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 278 | 2.8% | |
| 2227 | 6 | 0.1% | |
| 1763 | 6 | 0.1% | |
| 11628 | 5 | 0.1% | |
| 4801 | 5 | 0.1% | |
| 760 | 5 | 0.1% | |
| 5272 | 4 | < 0.1% | |
| 18550 | 4 | < 0.1% | |
| 15 | 4 | < 0.1% | |
| 5220 | 4 | < 0.1% | |
| Other values (8120) | 9679 | 96.8% |
| Value | Count | Frequency (%) | |
| 0 | 278 | 2.8% | |
| 1 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1207359 | 1 | < 0.1% | |
| 602519 | 1 | < 0.1% | |
| 508961 | 1 | < 0.1% | |
| 487589 | 1 | < 0.1% | |
| 423189 | 1 | < 0.1% |
| Distinct count | 1027 |
|---|---|
| Unique (%) | 10.3% |
| Missing | 26 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.450771 |
|---|---|
| Minimum | 0 |
| Maximum | 100.6 |
| Zeros | 254 |
| Zeros (%) | 2.5% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.8 |
| Q1 | 25 |
| median | 48.7 |
| Q3 | 71.8 |
| 95-th percentile | 93.6 |
| Maximum | 100.6 |
| Range | 100.6 |
| Interquartile range (IQR) | 46.8 |
Descriptive statistics
| Standard deviation | 28.22055724 |
|---|---|
| Coefficient of variation (CV) | 0.5824583727 |
| Kurtosis | -1.099296594 |
| Mean | 48.450771 |
| Median Absolute Deviation (MAD) | 24.12794997 |
| Skewness | -0.01672374423 |
| Sum | 483247.99 |
| Variance | 796.3998507 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 254 | 2.5% | |
| 46.6 | 21 | 0.2% | |
| 43.4 | 20 | 0.2% | |
| 0.1 | 20 | 0.2% | |
| 47.6 | 19 | 0.2% | |
| 56.8 | 19 | 0.2% | |
| 55.4 | 19 | 0.2% | |
| 53.6 | 19 | 0.2% | |
| 70 | 19 | 0.2% | |
| 31.4 | 18 | 0.2% | |
| Other values (1017) | 9546 | 95.5% | |
| (Missing) | 26 | 0.3% |
| Value | Count | Frequency (%) | |
| 0 | 254 | 2.5% | |
| 0.03 | 1 | < 0.1% | |
| 0.1 | 20 | 0.2% | |
| 0.12 | 1 | < 0.1% | |
| 0.2 | 11 | 0.1% |
| Value | Count | Frequency (%) | |
| 100.6 | 1 | < 0.1% | |
| 100 | 1 | < 0.1% | |
| 99.9 | 4 | < 0.1% | |
| 99.8 | 5 | 0.1% | |
| 99.7 | 3 | < 0.1% |
total_acc
Real number (ℝ≥0)
| Distinct count | 75 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.01130565 |
|---|---|
| Minimum | 1 |
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 13 |
| median | 20 |
| Q3 | 29 |
| 95-th percentile | 44 |
| Maximum | 90 |
| Range | 89 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 11.70939957 |
|---|---|
| Coefficient of variation (CV) | 0.5319720581 |
| Kurtosis | 0.9238037612 |
| Mean | 22.01130565 |
| Median Absolute Deviation (MAD) | 9.292220477 |
| Skewness | 0.8707976619 |
| Sum | 220003 |
| Variance | 137.1100383 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 15 | 369 | 3.7% | |
| 20 | 360 | 3.6% | |
| 17 | 360 | 3.6% | |
| 12 | 357 | 3.6% | |
| 14 | 351 | 3.5% | |
| 19 | 346 | 3.5% | |
| 16 | 340 | 3.4% | |
| 18 | 339 | 3.4% | |
| 13 | 331 | 3.3% | |
| 22 | 329 | 3.3% | |
| Other values (65) | 6513 | 65.1% |
| Value | Count | Frequency (%) | |
| 1 | 3 | < 0.1% | |
| 2 | 10 | 0.1% | |
| 3 | 58 | 0.6% | |
| 4 | 115 | 1.1% | |
| 5 | 144 | 1.4% |
| Value | Count | Frequency (%) | |
| 90 | 1 | < 0.1% | |
| 81 | 1 | < 0.1% | |
| 80 | 1 | < 0.1% | |
| 79 | 1 | < 0.1% | |
| 78 | 1 | < 0.1% |
initial_list_status
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| f | |
|---|---|
| m | 17 |
| Value | Count | Frequency (%) | |
| f | 9983 | 99.8% | |
| m | 17 | 0.2% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
collections_12_mths_ex_med
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 32 |
| Missing (%) | 0.3% |
| Memory size | 78.2 KiB |
| 0 | |
|---|---|
| (Missing) | 32 |
| Value | Count | Frequency (%) | |
| 0 | 9968 | 99.7% | |
| (Missing) | 32 | 0.3% |
mths_since_last_major_derog
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| 2 | |
|---|---|
| 3 | |
| 1 |
| Value | Count | Frequency (%) | |
| 2 | 3424 | 34.2% | |
| 3 | 3299 | 33.0% | |
| 1 | 3277 | 32.8% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 3 | 100.0% |
policy_code
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| pc3 | |
|---|---|
| pc5 | |
| pc1 | |
| pc2 | |
| pc4 |
| Value | Count | Frequency (%) | |
| pc3 | 2098 | 21.0% | |
| pc5 | 2025 | 20.2% | |
| pc1 | 1978 | 19.8% | |
| pc2 | 1962 | 19.6% | |
| pc4 | 1937 | 19.4% |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 5 | 71.4% | |
| Lowercase_Letter | 2 | 28.6% |
| Value | Count | Frequency (%) | |
| Common | 5 | 71.4% | |
| Latin | 2 | 28.6% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
cr_line_yrs
Real number (ℝ≥0)
| Distinct count | 50 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1997.014807 |
|---|---|
| Minimum | 1970 |
| Maximum | 2069 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1970 |
|---|---|
| 5-th percentile | 1984 |
| Q1 | 1994 |
| median | 1998 |
| Q3 | 2001 |
| 95-th percentile | 2006 |
| Maximum | 2069 |
| Range | 99 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 7.741003471 |
|---|---|
| Coefficient of variation (CV) | 0.003876287468 |
| Kurtosis | 21.63770675 |
| Mean | 1997.014807 |
| Median Absolute Deviation (MAD) | 5.242684033 |
| Skewness | 1.78954221 |
| Sum | 19960163 |
| Variance | 59.92313473 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2000 | 839 | 8.4% | |
| 1998 | 748 | 7.5% | |
| 1999 | 715 | 7.1% | |
| 2001 | 642 | 6.4% | |
| 1997 | 601 | 6.0% | |
| 1996 | 592 | 5.9% | |
| 1995 | 518 | 5.2% | |
| 1994 | 513 | 5.1% | |
| 2002 | 503 | 5.0% | |
| 2003 | 455 | 4.5% | |
| Other values (40) | 3869 | 38.7% |
| Value | Count | Frequency (%) | |
| 1970 | 14 | 0.1% | |
| 1971 | 11 | 0.1% | |
| 1972 | 13 | 0.1% | |
| 1973 | 18 | 0.2% | |
| 1974 | 14 | 0.1% |
| Value | Count | Frequency (%) | |
| 2069 | 9 | 0.1% | |
| 2068 | 7 | 0.1% | |
| 2067 | 6 | 0.1% | |
| 2066 | 2 | < 0.1% | |
| 2065 | 2 | < 0.1% |
cr_line_mths
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.855527764 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.546390325 |
|---|---|
| Coefficient of variation (CV) | 0.5173037653 |
| Kurtosis | -1.244692025 |
| Mean | 6.855527764 |
| Median Absolute Deviation (MAD) | 3.09118289 |
| Skewness | -0.1776976186 |
| Sum | 68521 |
| Variance | 12.57688434 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 1052 | 10.5% | |
| 11 | 999 | 10.0% | |
| 12 | 972 | 9.7% | |
| 9 | 923 | 9.2% | |
| 1 | 904 | 9.0% | |
| 8 | 794 | 7.9% | |
| 7 | 771 | 7.7% | |
| 5 | 740 | 7.4% | |
| 6 | 740 | 7.4% | |
| 2 | 728 | 7.3% | |
| Other values (2) | 1372 | 13.7% |
| Value | Count | Frequency (%) | |
| 1 | 904 | 9.0% | |
| 2 | 728 | 7.3% | |
| 3 | 696 | 7.0% | |
| 4 | 676 | 6.8% | |
| 5 | 740 | 7.4% |
| Value | Count | Frequency (%) | |
| 12 | 972 | 9.7% | |
| 11 | 999 | 10.0% | |
| 10 | 1052 | 10.5% | |
| 9 | 923 | 9.2% | |
| 8 | 794 | 7.9% |
cr_line_days
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 78.2 KiB |
| 1 | |
|---|---|
| (Missing) | 5 |
| Value | Count | Frequency (%) | |
| 1 | 9995 | > 99.9% | |
| (Missing) | 5 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| is_bad | emp_title | emp_length | home_ownership | annual_inc | verification_status | pymnt_plan | Notes | purpose_cat | purpose | zip_code | addr_state | debt_to_income | delinq_2yrs | inq_last_6mths | mths_since_last_delinq | mths_since_last_record | open_acc | pub_rec | revol_bal | revol_util | total_acc | initial_list_status | collections_12_mths_ex_med | mths_since_last_major_derog | policy_code | cr_line_yrs | cr_line_mths | cr_line_days | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | time warner cable | 10 | mortgage | 50000.0 | not verified | n | NaN | medical | medical | 766xx | tx | 10.87 | 0.0 | 0.0 | NaN | NaN | 15.0 | 0.0 | 12087 | 12.1 | 44.0 | f | 0.0 | 1 | pc4 | 1992.0 | 12.0 | 1.0 |
| 1 | 0 | ottawa university | 1 | rent | 39216.0 | not verified | n | borrower added on 04/14/11 > i will be using this loan to pay off expenses accrued in the last six months on my credit cards, due to a combination of job transition, relocation for the job, and medical expenses from a broken tibula. i generally overpay my monthly minimum on my debts, so i expect that this loan will be repaid sooner than 5 years. i have a steady job working in the information technology field, i've been employed full-time in this field for over eight years, and have been with my present employer for seven months in good standing. my monthly budget breakdown is 1/3 of my paycheck going to rent and bills, 1/3 going to living and job transit expenses, and 1/3 remaining for general spending and payments.<br/> | debt consolidation | my debt consolidation loan | 660xx | ks | 9.15 | 0.0 | 2.0 | NaN | NaN | 4.0 | 0.0 | 10114 | 64.0 | 5.0 | f | 0.0 | 2 | pc1 | 2005.0 | 11.0 | 1.0 |
| 2 | 0 | kennedy wilson | 4 | rent | 65000.0 | not verified | n | NaN | credit card | ap personal loan | 916xx | ca | 11.24 | 0.0 | 0.0 | NaN | NaN | 4.0 | 0.0 | 81 | 0.6 | 8.0 | f | 0.0 | 3 | pc4 | 1970.0 | 6.0 | 1.0 |
| 3 | 0 | town of plattekill | 10 | mortgage | 57500.0 | not verified | n | NaN | debt consolidation | debt consolidation loan | 124xx | ny | 6.18 | 1.0 | 0.0 | 16.0 | NaN | 6.0 | 0.0 | 10030 | 37.1 | 23.0 | f | 0.0 | 2 | pc2 | 1982.0 | 9.0 | 1.0 |
| 4 | 0 | belmont correctional | 10 | mortgage | 50004.0 | verified - income | n | i want to consolidate my debt, pay for a vacation and buy a ring. | debt consolidation | consolidate | 439xx | oh | 19.03 | 0.0 | 4.0 | NaN | NaN | 8.0 | 0.0 | 10740 | 40.4 | 21.0 | f | 0.0 | 3 | pc3 | 1999.0 | 10.0 | 1.0 |
| 5 | 0 | bae systems | 4 | rent | 47028.0 | verified - income | n | NaN | other | 16-oct-10 | 200xx | dc | 7.83 | 2.0 | 1.0 | 19.0 | NaN | 6.0 | 0.0 | 1715 | 26.4 | 25.0 | f | 0.0 | 3 | pc3 | 1999.0 | 12.0 | 1.0 |
| 6 | 0 | peninsula counseling center | 10 | mortgage | 126000.0 | not verified | n | borrower added on 05/18/10 > mick credit card consolidation loan - 100% payoff of credit card debt - amex, sears, macys and bank of america<br/> | credit card | mick credit card loan | 103xx | ny | 14.28 | 0.0 | 0.0 | NaN | NaN | 18.0 | 0.0 | 5466 | 11.1 | 29.0 | f | 0.0 | 3 | pc1 | 1979.0 | 11.0 | 1.0 |
| 7 | 0 | health plan of nevada | 6 | mortgage | 42000.0 | verified - income source | n | borrower added on 11/29/11 > loan is for debt consolidation and will be paid timely. employed in the healthcare industry for 6 years since moving to nv 7 years ago and have always had stable job positions. thank you very much for your assistance.<br> | debt consolidation | cc loan | 891xx | nv | 10.29 | 0.0 | 0.0 | NaN | NaN | 9.0 | 0.0 | 10354 | 95.9 | 10.0 | f | 0.0 | 3 | pc3 | 2006.0 | 4.0 | 1.0 |
| 8 | 0 | john deere | 2 | mortgage | 50000.0 | verified - income | n | NaN | debt consolidation | consolidation | 612xx | il | 15.36 | 0.0 | 2.0 | NaN | NaN | 11.0 | 0.0 | 19662 | 59.2 | 27.0 | f | 0.0 | 1 | pc5 | 2001.0 | 2.0 | 1.0 |
| 9 | 0 | NaN | 1 | rent | 40000.0 | not verified | n | this loan would be for a 2006 pt cruiser with only 300 miles on it. there is still a full warranty till dec. 2009 in effect. | car | fico score 762 want's to buy a new car | 926xx | ca | 6.48 | 0.0 | 1.0 | NaN | NaN | 11.0 | 0.0 | 19998 | 18.3 | 23.0 | f | 0.0 | 1 | pc5 | 1995.0 | 5.0 | 1.0 |
Last rows
| is_bad | emp_title | emp_length | home_ownership | annual_inc | verification_status | pymnt_plan | Notes | purpose_cat | purpose | zip_code | addr_state | debt_to_income | delinq_2yrs | inq_last_6mths | mths_since_last_delinq | mths_since_last_record | open_acc | pub_rec | revol_bal | revol_util | total_acc | initial_list_status | collections_12_mths_ex_med | mths_since_last_major_derog | policy_code | cr_line_yrs | cr_line_mths | cr_line_days | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | 0 | konica minolta | 10 | mortgage | 120000.0 | verified - income | n | i am looking ofr a loan so that i can replace my septic system. | home improvement | home improvment | 481xx | mi | 14.44 | 1.0 | 0.0 | 4.0 | NaN | 14.0 | 0.0 | 14716 | 59.8 | 31.0 | f | 0.0 | 2 | pc2 | 1994.0 | 2.0 | 1.0 |
| 9991 | 0 | ametek aerospace and defense | 10 | rent | 63000.0 | verified - income source | n | borrower added on 07/09/10 > loan app completed<br/>email verified<br/>bank account verified<br/> | medical | lasik | 018xx | ma | 10.08 | 0.0 | 0.0 | NaN | NaN | 6.0 | 0.0 | 60 | 1.1 | 22.0 | f | 0.0 | 3 | pc1 | 1989.0 | 5.0 | 1.0 |
| 9992 | 0 | the reis group | 10 | rent | 52000.0 | verified - income | n | borrower added on 12/14/11 > looking to be debt free in 3 yrs or less!!<br> | debt consolidation | consolidation | 124xx | ny | 23.70 | 0.0 | 0.0 | 70.0 | NaN | 8.0 | 0.0 | 15002 | 91.5 | 18.0 | f | 0.0 | 2 | pc5 | 1998.0 | 8.0 | 1.0 |
| 9993 | 0 | astoria fuel corp. | 10 | own | 95892.0 | verified - income | n | i live in a family owned home. it is my parents, but i am allowed to live here as long as i want as long as i pay for the taxes and any home improvements the home needs. i am looking for a loan to add a bathroom on the second floor and finish other small home improvements the house currently needs. i have lived here for 5 years and have done many updates already. this is the first major renovation i am doing on the house. i need the loan to get what i cannot do myself done the right way. i have excellent credit and pride myself on that. | home improvement | updates needed on family owned home | 110xx | ny | 8.70 | 0.0 | 2.0 | NaN | NaN | 3.0 | 0.0 | 2139 | 30.6 | 7.0 | f | 0.0 | 3 | pc5 | 1995.0 | 7.0 | 1.0 |
| 9994 | 1 | guitar center | 1 | rent | 24996.0 | verified - income source | n | NaN | debt consolidation | personal loan | 913xx | ca | 3.79 | 0.0 | 0.0 | NaN | NaN | 2.0 | 0.0 | 4801 | 56.5 | 7.0 | f | 0.0 | 1 | pc1 | 2005.0 | 8.0 | 1.0 |
| 9995 | 0 | cabot | 5 | mortgage | 66250.0 | verified - income | n | NaN | wedding | scottish wedding | 014xx | ma | 9.40 | 0.0 | 1.0 | NaN | NaN | 8.0 | 0.0 | 3656 | 24.1 | 10.0 | f | 0.0 | 2 | pc3 | 2001.0 | 9.0 | 1.0 |
| 9996 | 0 | gallant & wein | 1 | rent | 26000.0 | verified - income source | n | borrower added on 08/30/11 > credit cards consolidation and doctors bills..<br/> | debt consolidation | debt | 112xx | ny | 20.49 | 0.0 | 1.0 | 79.0 | NaN | 8.0 | 0.0 | 6709 | 58.9 | 12.0 | f | 0.0 | 2 | pc3 | 2000.0 | 5.0 | 1.0 |
| 9997 | 0 | weichert, realtors | 8 | rent | 47831.0 | not verified | n | borrower added on 03/10/10 > my dream is to finally end the cycle of revolving debt so that i can finally build a stable future for myself. i've been able to put some hardships behind and can see the light ahead if my loan is fully funded. i live modestly but cannot corral rising life expenses unless i can put away credit debt and service this loan. i will be a worthy lendingclub loan recipient. thank you for your consideration!<br/> | debt consolidation | harnessing credit debt for a stable future. | 070xx | nj | 24.13 | 0.0 | 0.0 | NaN | 111.0 | 9.0 | 1.0 | 11346 | 60.7 | 17.0 | f | 0.0 | 3 | pc3 | 1989.0 | 12.0 | 1.0 |
| 9998 | 0 | meadwestvaco | 6 | mortgage | 70000.0 | not verified | n | NaN | major purchase | personal | 244xx | va | 16.18 | 2.0 | 2.0 | 16.0 | NaN | 9.0 | 0.0 | 17157 | 50.9 | 27.0 | f | 0.0 | 2 | pc3 | 1999.0 | 3.0 | 1.0 |
| 9999 | 0 | rehab alliance | 1 | rent | 70560.0 | not verified | n | borrower added on 11/09/11 > order to pay back lenders quicker. also, never been late on a payment. job: very stable, full-time job (40 hours/wk). thank you!<br> | credit card | credit card loan | 900xx | ca | 16.13 | 0.0 | 1.0 | 53.0 | NaN | 15.0 | 0.0 | 2304 | 22.6 | 34.0 | f | 0.0 | 2 | pc5 | 2000.0 | 9.0 | 1.0 |